Creating Execute Package Task 13
· Always make Sure Dimension tables should loaded first and then load the Fact tables
· We need five Execute Package Task for populating Four Dimension and one Fact tables
· Right Click on SSIS Packages ---- > New SSIS Package
· Right Click on Package1.dtsx ----- > Click Rename ----- > Type Loading Dim and Fact Tables
· Drag and Drop Execute Package Task from SSIS Toolbox
· Right Click on Execute Package Task at Control flow Task ----- > Click Rename ---- > Type Populating Dim_Contract ----- > Click Enter
· After renaming it appears like below
· Double Click on Populating Dim_Contract
· Click Packages ---- > Click on the Drop Down of the Package name from Project reference ---- > Choose Dim_Contract.dtsx ----- > Click Ok
· Drag and Drop Execute Package Task below the Populating Dim_Contract
· Provide the Connection by Dragging Green arrow and Place it on Top of Execute Package Task
· Right Click on Execute Package Task ---- > Click Rename ---- > Type Populating Dim_Mortgage
· Double Click on Populating Dim_Mortgage
· Click on Package ---- > Click on Drop Down of Package Name from Project Reference ----- > Choose Dim_Mortgage.dtsx
· Drag and Drop Execute Package Task below Populating Dim_Mortgage
· Provide the Connection by Dragging Green arrow and place it on top of Execute Package Task
· Right Click on Execute Package Task ---- > Click Rename ---- > Type Populating Dim_Owner
· Double Click on Populating Dim_Owner
· Click on Package ---- > Click on Drop Down of Package Name from Project Reference ----- > Choose Dim_Owner.dtsx
· Drag and Drop Execute Package Task below Populating Dim_Owner
· Provide the Connection by Dragging Green arrow and place it on top of Execute Package Task
· Right Click on Execute Package Task ---- > Click Rename ---- > Type Populating Dim_Property
· Double Click on Populating Dim_Property
· Click on Package ---- > Click on Drop Down of Package Name from Project Reference ----- > Choose Dim_Property.dtsx
· Drag and Drop Execute Package Task below Populating Dim_Property
· Provide the Connection by Dragging Green arrow and place it on top of Execute Package Task
· Right Click on Execute Package Task ---- > Click Rename ---- > Type Populating Fact_Mortgage
· Double Click on Populating Fact_Mortgage
· Click on Package ---- > Click on Drop Down of Package Name from Project Reference ----- > Choose Fact_Mortgage.dtsx
· Finally Package looks like below
· To execute the Package ---- > Click Start at Top
· Files are executed successfully without any error
· All the Tables are populated with values.
· In SQL Server Management Studio, Use the Code to see Whether the Tables are Populated
USE [Mortgage Datamart]
GO
Select * From Dim_Contract
· Copy and Paste the Code in Query Window ---- > Click Execute
· Dim_Contract table is populated with records
Script to check Dim_Mortgage
USE[Mortgage Datamart]
GO
Select * From Dim_Mortgage
· Copy and Paste the Code in Query Window ---- > Click Execute
· Dim_Mortgage table is populated with records
Script to check Dim_Owner
USE[Mortgage Datamart]
GO
Select * From Dim_Owner
· Copy and Paste the Code in Query Window ---- > Click Execute
· Dim_Owner table is populated with records
Script to Check Dim_Property
USE[Mortgage Datamart]
GO
Select * From Dim_Property
· Copy and Paste the Code in Query Window ---- > Click Execute
· Dim_Property table is populated with records
Script to Check Fact_Mortgage Table
USE [Mortgage Datamart]
Go
Select * From Fact_Mortgage
· · Fact_Mortgage table is populated with records
Video for Execute package Task